[dbo].[Log

[dbo].[Log_Main]

SQLServer > iMIS1521GA > Tables > dbo.Log_Main

Properties
Columns
SQL Script
Uses

Property	Value
Heap
Row Count	0
Created	10:31:27 AM Tuesday, March 02, 2010
Last Modified	10:31:27 AM Tuesday, March 02, 2010

Columns

Name	Data Type	Max Length (Bytes)
LOG_SEQN	int	4
TIME_STAMP	datetime	8
UPDATED_BY	varchar(60)	60
ACTION_TYPE	smallint	2
TABLE_NAME	varchar(30)	30
KEY_CLUSTER	varchar(80)	80

SQL Script

CREATE TABLE [dbo].[Log_Main]
(
[LOG_SEQN] [int] NOT NULL,
[TIME_STAMP] [datetime] NULL,
[UPDATED_BY] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ACTION_TYPE] [smallint] NOT NULL,
[TABLE_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[KEY_CLUSTER] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]

GO

Uses